﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="kqjl.aspx.cs" Inherits="kqjl" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
    .style1
    {
        width: 100%;
    }
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><asp:SqlDataSource ID="SqlDataSourceNDYF" runat="server" 
    ConnectionString="<%$ ConnectionStrings:qynbControlSystemConnectionString %>" 
    SelectCommand="SELECT DISTINCT kqndyf FROM kqinfo"></asp:SqlDataSource>
<table class="style1">
    <tr>
        <td>
            <asp:Label ID="lblYF" runat="server" Text="查询考勤月份"></asp:Label>
        </td>
        <td>
            <asp:DropDownList ID="ddlNDYF" runat="server" AutoPostBack="True" 
                DataSourceID="SqlDataSourceNDYF" DataTextField="kqndyf" DataValueField="kqndyf">
            </asp:DropDownList>
        </td>
    </tr>
</table>
<asp:GridView ID="GridViewKQJL" runat="server" AllowPaging="True" 
    AutoGenerateColumns="False" DataSourceID="SqlDataSourceKQJL" 
    EnableModelValidation="True" PageSize="20" Width="492px">
    <Columns>
        <asp:BoundField DataField="kqID" HeaderText="流水码" InsertVisible="False" 
            ReadOnly="True" SortExpression="kqID" />
        <asp:BoundField DataField="c_Name" HeaderText="姓名" SortExpression="c_Name" />
        <asp:BoundField DataField="kqndyf" HeaderText="考勤月份" SortExpression="kqndyf" />
        <asp:BoundField DataField="kqrq" HeaderText="日期" SortExpression="kqrq" />
        <asp:BoundField DataField="sjd" HeaderText="时间点" SortExpression="sjd" />
        <asp:BoundField DataField="remark" HeaderText="情况" SortExpression="remark" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSourceKQJL" runat="server" 
    ConnectionString="<%$ ConnectionStrings:qynbControlSystemConnectionString %>" 
    SelectCommand="SELECT kqinfo.kqID, kqinfo.cusID, cusInfo.c_Name, kqinfo.kqndyf, kqinfo.kqrq, kqinfo.sjd, kqinfo.remark FROM kqinfo INNER JOIN cusInfo ON cusInfo.cusID = kqinfo.cusID WHERE (kqinfo.kqndyf = @kqndyf)">
    <SelectParameters>
        <asp:ControlParameter ControlID="ddlNDYF" Name="kqndyf" 
            PropertyName="SelectedValue" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>
&nbsp;
</asp:Content>

